import os
from dotenv import load_dotenv, dotenv_values
import psycopg2
import polars as pl
import plotly.graph_objects as go
import plotly.io as pio
pio.renderers.default = 'notebook' # Use 'notebook', 'browser', or 'colab' if necessary
from datetime import datetime, date, time, timedeltaFRED API Analysis
FRED API Data Retrieval and Analysis
Import Series data
import os
from dotenv import load_dotenv
from fredapi import Fred
# Load API key from .env
load_dotenv()
fred = Fred(api_key=os.getenv("FRED_API_KEY"))
# List of series IDs
series_ids = [
"UNRATE", "CIVPART", "PAYEMS"
]
# Download data
data = {sid: fred.get_series(sid) for sid in series_ids}
# Example: print first few rows of unemployment rate
data["UNRATE"].head()1948-01-01 3.4
1948-02-01 3.8
1948-03-01 4.0
1948-04-01 3.9
1948-05-01 3.5
dtype: float64
import plotly.graph_objects as go
# plot UNRATE
fig = go.Figure()
fig.add_trace(go.Scatter(x=data["UNRATE"].index, y=data["UNRATE"], mode='lines', name='Unemployment Rate'))
fig.update_layout(title='Unemployment Rate Over Time', xaxis_title='Date', yaxis_title='Unemployment Rate (%)')
fig.show()